------------------------------------------------------------------------------------------------------------------------
      name:  <unnamed>
       log:  /Users/caseyklofstad/Dropbox/Effects, Impacts and Influences of Hurricane Irma/irma paper 2 BUSINESS price 
> gouging experiment/replication files/study 2 log.log
  log type:  text
 opened on:   8 Feb 2023, 16:10:51

. 
. *get data
. import delimited "/Users/caseyklofstad/Dropbox/u-link phase i survey 2/data/ulink_p1_s2_useable_data.csv"
(encoding automatically selected: ISO-8859-1)
(185 vars, 2,023 obs)

. 
. *extract vars for analysis
. keep q39 q41 q43 q45 q46 q1 q5 q4 q3 q2_1 q2_2 q2_3 q2_4 q2_5 q2_6 q11a

. 
. *create factor variable for experimental condition
. generate gouge=.
(2,023 missing values generated)

.                 *control
. replace gouge=1 if q39 !=.
(413 real changes made)

. tab q39

        Q39 |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |        347       84.02       84.02
          2 |         29        7.02       91.04
          3 |         37        8.96      100.00
------------+-----------------------------------
      Total |        413      100.00

. tab gouge

      gouge |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |        413      100.00      100.00
------------+-----------------------------------
      Total |        413      100.00

. tab gouge q39   

           |               Q39
     gouge |         1          2          3 |     Total
-----------+---------------------------------+----------
         1 |       347         29         37 |       413 
-----------+---------------------------------+----------
     Total |       347         29         37 |       413 

.                 *stores might run out of goods
. replace gouge=2 if q41 !=.
(405 real changes made)

. tab q41

        Q41 |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |        313       77.28       77.28
          2 |         40        9.88       87.16
          3 |         52       12.84      100.00
------------+-----------------------------------
      Total |        405      100.00

. tab gouge

      gouge |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |        413       50.49       50.49
          2 |        405       49.51      100.00
------------+-----------------------------------
      Total |        818      100.00

. tab gouge q41

           |               Q41
     gouge |         1          2          3 |     Total
-----------+---------------------------------+----------
         2 |       313         40         52 |       405 
-----------+---------------------------------+----------
     Total |       313         40         52 |       405 

.                 *stores close
. replace gouge=3 if q43 !=.
(401 real changes made)

. tab q43

        Q43 |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |        312       77.81       77.81
          2 |         31        7.73       85.54
          3 |         58       14.46      100.00
------------+-----------------------------------
      Total |        401      100.00

. tab gouge

      gouge |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |        413       33.88       33.88
          2 |        405       33.22       67.10
          3 |        401       32.90      100.00
------------+-----------------------------------
      Total |      1,219      100.00

. tab gouge q43

           |               Q43
     gouge |         1          2          3 |     Total
-----------+---------------------------------+----------
         3 |       312         31         58 |       401 
-----------+---------------------------------+----------
     Total |       312         31         58 |       401 

.                 *stores might run out of goods + EXPERT
. replace gouge=4 if q45 !=.
(409 real changes made)

. tab q45

        Q45 |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |        308       75.31       75.31
          2 |         46       11.25       86.55
          3 |         55       13.45      100.00
------------+-----------------------------------
      Total |        409      100.00

. tab gouge

      gouge |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |        413       25.37       25.37
          2 |        405       24.88       50.25
          3 |        401       24.63       74.88
          4 |        409       25.12      100.00
------------+-----------------------------------
      Total |      1,628      100.00

. tab gouge q45

           |               Q45
     gouge |         1          2          3 |     Total
-----------+---------------------------------+----------
         4 |       308         46         55 |       409 
-----------+---------------------------------+----------
     Total |       308         46         55 |       409 

.                 *stores close + EXPERT
. replace gouge=5 if q46 !=.
(395 real changes made)

. tab q46

        Q46 |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |        312       78.99       78.99
          2 |         32        8.10       87.09
          3 |         51       12.91      100.00
------------+-----------------------------------
      Total |        395      100.00

. tab gouge

      gouge |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |        413       20.42       20.42
          2 |        405       20.02       40.43
          3 |        401       19.82       60.26
          4 |        409       20.22       80.47
          5 |        395       19.53      100.00
------------+-----------------------------------
      Total |      2,023      100.00

. tab gouge q46

           |               Q46
     gouge |         1          2          3 |     Total
-----------+---------------------------------+----------
         5 |       312         32         51 |       395 
-----------+---------------------------------+----------
     Total |       312         32         51 |       395 

.                 *summary
. label define gouge_label 1 "control" 2 "stores run out" 3 "stores close" 4 "stores run out + EXPERT " 5 "stores close 
> + EXPERT" 

. label values gouge gouge_label

. tab gouge

                   gouge |      Freq.     Percent        Cum.
-------------------------+-----------------------------------
                 control |        413       20.42       20.42
          stores run out |        405       20.02       40.43
            stores close |        401       19.82       60.26
stores run out + EXPERT  |        409       20.22       80.47
   stores close + EXPERT |        395       19.53      100.00
-------------------------+-----------------------------------
                   Total |      2,023      100.00

. summarize gouge

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
       gouge |      2,023    2.984182    1.414475          1          5

. 
. *create create factor variable for experimental condition, this time control vs all treats
. generate gouge_pooled=.
(2,023 missing values generated)

.                 *control
. replace gouge_pooled=1 if q39 !=.
(413 real changes made)

. tab q39

        Q39 |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |        347       84.02       84.02
          2 |         29        7.02       91.04
          3 |         37        8.96      100.00
------------+-----------------------------------
      Total |        413      100.00

. tab gouge_pooled

gouge_poole |
          d |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |        413      100.00      100.00
------------+-----------------------------------
      Total |        413      100.00

. tab gouge_pooled q39    

gouge_pool |               Q39
        ed |         1          2          3 |     Total
-----------+---------------------------------+----------
         1 |       347         29         37 |       413 
-----------+---------------------------------+----------
     Total |       347         29         37 |       413 

.                 *stores might run out of goods
. replace gouge_pooled=2 if q41 !=.
(405 real changes made)

. tab q41

        Q41 |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |        313       77.28       77.28
          2 |         40        9.88       87.16
          3 |         52       12.84      100.00
------------+-----------------------------------
      Total |        405      100.00

. tab gouge_pooled

gouge_poole |
          d |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |        413       50.49       50.49
          2 |        405       49.51      100.00
------------+-----------------------------------
      Total |        818      100.00

. tab gouge_pooled q41

gouge_pool |               Q41
        ed |         1          2          3 |     Total
-----------+---------------------------------+----------
         2 |       313         40         52 |       405 
-----------+---------------------------------+----------
     Total |       313         40         52 |       405 

.                 *stores close
. replace gouge_pooled=2 if q43 !=.
(401 real changes made)

. tab q43

        Q43 |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |        312       77.81       77.81
          2 |         31        7.73       85.54
          3 |         58       14.46      100.00
------------+-----------------------------------
      Total |        401      100.00

. tab gouge_pooled

gouge_poole |
          d |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |        413       33.88       33.88
          2 |        806       66.12      100.00
------------+-----------------------------------
      Total |      1,219      100.00

. tab gouge_pooled q43

gouge_pool |               Q43
        ed |         1          2          3 |     Total
-----------+---------------------------------+----------
         2 |       312         31         58 |       401 
-----------+---------------------------------+----------
     Total |       312         31         58 |       401 

.                 *stores might run out of goods + EXPERT
. replace gouge_pooled=2 if q45 !=.
(409 real changes made)

. tab q45

        Q45 |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |        308       75.31       75.31
          2 |         46       11.25       86.55
          3 |         55       13.45      100.00
------------+-----------------------------------
      Total |        409      100.00

. tab gouge_pooled

gouge_poole |
          d |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |        413       25.37       25.37
          2 |      1,215       74.63      100.00
------------+-----------------------------------
      Total |      1,628      100.00

. tab gouge_pooled q45

gouge_pool |               Q45
        ed |         1          2          3 |     Total
-----------+---------------------------------+----------
         2 |       308         46         55 |       409 
-----------+---------------------------------+----------
     Total |       308         46         55 |       409 

.                 *stores close + EXPERT
. replace gouge_pooled=2 if q46 !=.
(395 real changes made)

. tab q46

        Q46 |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |        312       78.99       78.99
          2 |         32        8.10       87.09
          3 |         51       12.91      100.00
------------+-----------------------------------
      Total |        395      100.00

. tab gouge_pooled

gouge_poole |
          d |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |        413       20.42       20.42
          2 |      1,610       79.58      100.00
------------+-----------------------------------
      Total |      2,023      100.00

. tab gouge_pooled q46

gouge_pool |               Q46
        ed |         1          2          3 |     Total
-----------+---------------------------------+----------
         2 |       312         32         51 |       395 
-----------+---------------------------------+----------
     Total |       312         32         51 |       395 

.                 *summary
. label define gouge_pooled_label 1 "control" 2 "treat pooled" 

. label values gouge_pooled gouge_pooled_label

. tab gouge_pooled

gouge_pooled |      Freq.     Percent        Cum.
-------------+-----------------------------------
     control |        413       20.42       20.42
treat pooled |      1,610       79.58      100.00
-------------+-----------------------------------
       Total |      2,023      100.00

. summarize gouge_pooled

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
gouge_pooled |      2,023    1.795848    .4031804          1          2

. 
. *balance analysis
.         *clean up covariates
.                 *sex
. tab q1

         Q1 |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |        986       48.74       48.74
          2 |      1,037       51.26      100.00
------------+-----------------------------------
      Total |      2,023      100.00

. generate female=.
(2,023 missing values generated)

. replace female=0 if q1==1
(986 real changes made)

. replace female=1 if q1==2
(1,037 real changes made)

. tab q1 female

           |        female
        Q1 |         0          1 |     Total
-----------+----------------------+----------
         1 |       986          0 |       986 
         2 |         0      1,037 |     1,037 
-----------+----------------------+----------
     Total |       986      1,037 |     2,023 

.                 *age
. tab q5

         Q5 |      Freq.     Percent        Cum.
------------+-----------------------------------
       1929 |          1        0.05        0.05
       1932 |          1        0.05        0.10
       1935 |          2        0.10        0.20
       1937 |          2        0.10        0.30
       1938 |          6        0.30        0.59
       1939 |          5        0.25        0.84
       1940 |          3        0.15        0.99
       1941 |          7        0.35        1.33
       1942 |          2        0.10        1.43
       1943 |          6        0.30        1.73
       1944 |          9        0.44        2.17
       1945 |         15        0.74        2.92
       1946 |          8        0.40        3.31
       1947 |         13        0.64        3.95
       1948 |         22        1.09        5.04
       1949 |         11        0.54        5.59
       1950 |         17        0.84        6.43
       1951 |         12        0.59        7.02
       1952 |         24        1.19        8.21
       1953 |         30        1.48        9.69
       1954 |         24        1.19       10.87
       1955 |         22        1.09       11.96
       1956 |         17        0.84       12.80
       1957 |         28        1.38       14.19
       1958 |         34        1.68       15.87
       1959 |         25        1.24       17.10
       1960 |         28        1.38       18.49
       1961 |         29        1.43       19.92
       1962 |         30        1.48       21.40
       1963 |         31        1.53       22.94
       1964 |         36        1.78       24.72
       1965 |         23        1.14       25.85
       1966 |         33        1.63       27.48
       1967 |         28        1.38       28.87
       1968 |         25        1.24       30.10
       1969 |         29        1.43       31.54
       1970 |         35        1.73       33.27
       1971 |         22        1.09       34.35
       1972 |         30        1.48       35.84
       1973 |         23        1.14       36.97
       1974 |         30        1.48       38.46
       1975 |         42        2.08       40.53
       1976 |         32        1.58       42.12
       1977 |         31        1.53       43.65
       1978 |         44        2.17       45.82
       1979 |         54        2.67       48.49
       1980 |         50        2.47       50.96
       1981 |         41        2.03       52.99
       1982 |         49        2.42       55.41
       1983 |         41        2.03       57.44
       1984 |         54        2.67       60.11
       1985 |         59        2.92       63.03
       1986 |         46        2.27       65.30
       1987 |         46        2.27       67.57
       1988 |         44        2.17       69.75
       1989 |         41        2.03       71.77
       1990 |         69        3.41       75.19
       1991 |         45        2.22       77.41
       1992 |         46        2.27       79.68
       1993 |         40        1.98       81.66
       1994 |         37        1.83       83.49
       1995 |         55        2.72       86.21
       1996 |         43        2.13       88.33
       1997 |         37        1.83       90.16
       1998 |         39        1.93       92.09
       1999 |         39        1.93       94.02
       2000 |         54        2.67       96.69
       2001 |         49        2.42       99.11
       2002 |         18        0.89      100.00
------------+-----------------------------------
      Total |      2,023      100.00

.                         *convert yob to age
. generate age=2020-q5

. tab age

        age |      Freq.     Percent        Cum.
------------+-----------------------------------
         18 |         18        0.89        0.89
         19 |         49        2.42        3.31
         20 |         54        2.67        5.98
         21 |         39        1.93        7.91
         22 |         39        1.93        9.84
         23 |         37        1.83       11.67
         24 |         43        2.13       13.79
         25 |         55        2.72       16.51
         26 |         37        1.83       18.34
         27 |         40        1.98       20.32
         28 |         46        2.27       22.59
         29 |         45        2.22       24.81
         30 |         69        3.41       28.23
         31 |         41        2.03       30.25
         32 |         44        2.17       32.43
         33 |         46        2.27       34.70
         34 |         46        2.27       36.97
         35 |         59        2.92       39.89
         36 |         54        2.67       42.56
         37 |         41        2.03       44.59
         38 |         49        2.42       47.01
         39 |         41        2.03       49.04
         40 |         50        2.47       51.51
         41 |         54        2.67       54.18
         42 |         44        2.17       56.35
         43 |         31        1.53       57.88
         44 |         32        1.58       59.47
         45 |         42        2.08       61.54
         46 |         30        1.48       63.03
         47 |         23        1.14       64.16
         48 |         30        1.48       65.65
         49 |         22        1.09       66.73
         50 |         35        1.73       68.46
         51 |         29        1.43       69.90
         52 |         25        1.24       71.13
         53 |         28        1.38       72.52
         54 |         33        1.63       74.15
         55 |         23        1.14       75.28
         56 |         36        1.78       77.06
         57 |         31        1.53       78.60
         58 |         30        1.48       80.08
         59 |         29        1.43       81.51
         60 |         28        1.38       82.90
         61 |         25        1.24       84.13
         62 |         34        1.68       85.81
         63 |         28        1.38       87.20
         64 |         17        0.84       88.04
         65 |         22        1.09       89.13
         66 |         24        1.19       90.31
         67 |         30        1.48       91.79
         68 |         24        1.19       92.98
         69 |         12        0.59       93.57
         70 |         17        0.84       94.41
         71 |         11        0.54       94.96
         72 |         22        1.09       96.05
         73 |         13        0.64       96.69
         74 |          8        0.40       97.08
         75 |         15        0.74       97.83
         76 |          9        0.44       98.27
         77 |          6        0.30       98.57
         78 |          2        0.10       98.67
         79 |          7        0.35       99.01
         80 |          3        0.15       99.16
         81 |          5        0.25       99.41
         82 |          6        0.30       99.70
         83 |          2        0.10       99.80
         85 |          2        0.10       99.90
         88 |          1        0.05       99.95
         91 |          1        0.05      100.00
------------+-----------------------------------
      Total |      2,023      100.00

.                 *income
. tab q4

         Q4 |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |        362       17.89       17.89
          2 |        461       22.79       40.68
          3 |        436       21.55       62.23
          4 |        245       12.11       74.35
          5 |        283       13.99       88.33
          6 |        114        5.64       93.97
          7 |        122        6.03      100.00
------------+-----------------------------------
      Total |      2,023      100.00

.                 *education
. tab q3

         Q3 |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |         93        4.60        4.60
          2 |        721       35.64       40.24
          3 |        407       20.12       60.36
          4 |        197        9.74       70.09
          5 |        380       18.78       88.88
          6 |        225       11.12      100.00
------------+-----------------------------------
      Total |      2,023      100.00

.                 *race
. tab q2_1

       Q2_1 |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |      1,306      100.00      100.00
------------+-----------------------------------
      Total |      1,306      100.00

. tab q2_2

       Q2_2 |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |        305      100.00      100.00
------------+-----------------------------------
      Total |        305      100.00

. tab q2_3

       Q2_3 |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |        361      100.00      100.00
------------+-----------------------------------
      Total |        361      100.00

. tab q2_4

       Q2_4 |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |        150      100.00      100.00
------------+-----------------------------------
      Total |        150      100.00

. tab q2_5

       Q2_5 |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |         46      100.00      100.00
------------+-----------------------------------
      Total |         46      100.00

. tab q2_6

       Q2_6 |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |         48      100.00      100.00
------------+-----------------------------------
      Total |         48      100.00

. generate nonwhite=.
(2,023 missing values generated)

. replace nonwhite=1 if q2_1==.
(717 real changes made)

. replace nonwhite=0 if q2_1==1
(1,306 real changes made)

. tab q2_1 nonwhite

           |  nonwhite
      Q2_1 |         0 |     Total
-----------+-----------+----------
         1 |     1,306 |     1,306 
-----------+-----------+----------
     Total |     1,306 |     1,306 

. tab q2_2 nonwhite

           |       nonwhite
      Q2_2 |         0          1 |     Total
-----------+----------------------+----------
         1 |        20        285 |       305 
-----------+----------------------+----------
     Total |        20        285 |       305 

. tab q2_3 nonwhite

           |       nonwhite
      Q2_3 |         0          1 |     Total
-----------+----------------------+----------
         1 |        79        282 |       361 
-----------+----------------------+----------
     Total |        79        282 |       361 

. tab q2_4 nonwhite

           |       nonwhite
      Q2_4 |         0          1 |     Total
-----------+----------------------+----------
         1 |        17        133 |       150 
-----------+----------------------+----------
     Total |        17        133 |       150 

. tab q2_5 nonwhite

           |       nonwhite
      Q2_5 |         0          1 |     Total
-----------+----------------------+----------
         1 |        18         28 |        46 
-----------+----------------------+----------
     Total |        18         28 |        46 

. tab q2_6 nonwhite

           |       nonwhite
      Q2_6 |         0          1 |     Total
-----------+----------------------+----------
         1 |         6         42 |        48 
-----------+----------------------+----------
     Total |         6         42 |        48 

.                 *party id (based on first screener question)
. tab q11a

       Q11a |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |        835       41.28       41.28
          2 |        564       27.88       69.15
          3 |        487       24.07       93.23
          4 |        137        6.77      100.00
------------+-----------------------------------
      Total |      2,023      100.00

. recode q11a (1=1) (2=0) (3=0) (4=0), gen(pid_DEM)
(1188 differences between q11a and pid_DEM)

. recode q11a (1=0) (2=1) (3=0) (4=0), gen(pid_REP)
(2023 differences between q11a and pid_REP)

. tab q11a pid_DEM

           | RECODE of q11a (Q11a)
      Q11a |         0          1 |     Total
-----------+----------------------+----------
         1 |         0        835 |       835 
         2 |       564          0 |       564 
         3 |       487          0 |       487 
         4 |       137          0 |       137 
-----------+----------------------+----------
     Total |     1,188        835 |     2,023 

. tab q11a pid_REP

           | RECODE of q11a (Q11a)
      Q11a |         0          1 |     Total
-----------+----------------------+----------
         1 |       835          0 |       835 
         2 |         0        564 |       564 
         3 |       487          0 |       487 
         4 |       137          0 |       137 
-----------+----------------------+----------
     Total |     1,459        564 |     2,023 

.         *multinomial logit with control as base category
. mlogit gouge female age q4 q3 nonwhite pid_DEM pid_REP, b(1)

Iteration 0:   log likelihood = -3255.6514  
Iteration 1:   log likelihood = -3236.2575  
Iteration 2:   log likelihood = -3236.2175  
Iteration 3:   log likelihood = -3236.2175  

Multinomial logistic regression                         Number of obs =  2,023
                                                        LR chi2(28)   =  38.87
                                                        Prob > chi2   = 0.0831
Log likelihood = -3236.2175                             Pseudo R2     = 0.0060

-----------------------------------------------------------------------------------------
                  gouge | Coefficient  Std. err.      z    P>|z|     [95% conf. interval]
------------------------+----------------------------------------------------------------
control                 |  (base outcome)
------------------------+----------------------------------------------------------------
stores_run_out          |
                 female |   .0192832   .1465245     0.13   0.895    -.2678996     .306466
                    age |   .0004195   .0046131     0.09   0.928     -.008622    .0094611
                     q4 |  -.0111059    .045498    -0.24   0.807    -.1002803    .0780686
                     q3 |  -.1044986   .0532712    -1.96   0.050    -.2089083    -.000089
               nonwhite |   .2761121   .1654504     1.67   0.095    -.0481647    .6003889
                pid_DEM |  -.0977275   .1678651    -0.58   0.560    -.4267372    .2312821
                pid_REP |   .1834373   .1867057     0.98   0.326    -.1824992    .5493738
                  _cons |    .232576   .3042991     0.76   0.445    -.3638392    .8289913
------------------------+----------------------------------------------------------------
stores_close            |
                 female |  -.0782536   .1469108    -0.53   0.594    -.3661934    .2096862
                    age |   .0114523   .0045709     2.51   0.012     .0024936     .020411
                     q4 |  -.0762334   .0462289    -1.65   0.099    -.1668404    .0143736
                     q3 |  -.0798092   .0537077    -1.49   0.137    -.1850744     .025456
               nonwhite |   .2822274   .1660343     1.70   0.089    -.0431939    .6076487
                pid_DEM |   .1111572   .1673832     0.66   0.507    -.2169079    .4392222
                pid_REP |   .0660621   .1922898     0.34   0.731     -.310819    .4429431
                  _cons |  -.1405345   .3079357    -0.46   0.648    -.7440774    .4630083
------------------------+----------------------------------------------------------------
stores_run_out___EXPERT |
                 female |  -.1006057   .1461004    -0.69   0.491    -.3869573    .1857459
                    age |  -.0030345    .004612    -0.66   0.511    -.0120738    .0060049
                     q4 |   .0305476   .0448409     0.68   0.496    -.0573388    .1184341
                     q3 |  -.0537787   .0526836    -1.02   0.307    -.1570367    .0494794
               nonwhite |   .0387478    .165315     0.23   0.815    -.2852637    .3627592
                pid_DEM |    .069298   .1668568     0.42   0.678    -.2577354    .3963314
                pid_REP |   .0994986   .1886865     0.53   0.598    -.2703202    .4693174
                  _cons |   .1831701    .303236     0.60   0.546    -.4111614    .7775017
------------------------+----------------------------------------------------------------
stores_close___EXPERT   |
                 female |  -.0229387   .1477728    -0.16   0.877     -.312568    .2666905
                    age |   .0018561   .0046236     0.40   0.688     -.007206    .0109182
                     q4 |   .0123434   .0455386     0.27   0.786    -.0769106    .1015974
                     q3 |  -.0877831   .0534632    -1.64   0.101    -.1925691    .0170029
               nonwhite |   .1938771   .1679581     1.15   0.248    -.1353147    .5230689
                pid_DEM |  -.0898444   .1708316    -0.53   0.599    -.4246682    .2449794
                pid_REP |   .2947265    .186299     1.58   0.114    -.0704129    .6598658
                  _cons |   .0306673   .3072398     0.10   0.920    -.5715116    .6328462
-----------------------------------------------------------------------------------------

. 
. *combine and code y/n/dk on PRO anti-gouging law regardless of treatment (include DK responses; 3 = yes ban gouging, 1
>  = no don't, 2 = dk)
. generate no_gouge_all=.
(2,023 missing values generated)

.         *yes, supprt law
. replace no_gouge_all=3 if q39==1 | q41==1 | q43==1 | q45==1 | q46==1
(1,592 real changes made)

.         *no, do not support law
. replace no_gouge_all=1 if q39==2 | q41==2 | q43==2 | q45==2 | q46==2
(178 real changes made)

.         *dk
. replace no_gouge_all=2 if q39==3 | q41==3 | q43==3 | q45==3 | q46==3
(253 real changes made)

.         *stats/check coding
. tab q39

        Q39 |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |        347       84.02       84.02
          2 |         29        7.02       91.04
          3 |         37        8.96      100.00
------------+-----------------------------------
      Total |        413      100.00

. tab q41

        Q41 |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |        313       77.28       77.28
          2 |         40        9.88       87.16
          3 |         52       12.84      100.00
------------+-----------------------------------
      Total |        405      100.00

. tab q43

        Q43 |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |        312       77.81       77.81
          2 |         31        7.73       85.54
          3 |         58       14.46      100.00
------------+-----------------------------------
      Total |        401      100.00

. tab q45

        Q45 |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |        308       75.31       75.31
          2 |         46       11.25       86.55
          3 |         55       13.45      100.00
------------+-----------------------------------
      Total |        409      100.00

. tab q46

        Q46 |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |        312       78.99       78.99
          2 |         32        8.10       87.09
          3 |         51       12.91      100.00
------------+-----------------------------------
      Total |        395      100.00

. tab no_gouge_all

no_gouge_al |
          l |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |        178        8.80        8.80
          2 |        253       12.51       21.30
          3 |      1,592       78.70      100.00
------------+-----------------------------------
      Total |      2,023      100.00

.         *look at dk's by treatment condition
. tab gouge no_gouge_all

                      |           no_gouge_all
                gouge |         1          2          3 |     Total
----------------------+---------------------------------+----------
              control |        29         37        347 |       413 
       stores run out |        40         52        313 |       405 
         stores close |        31         58        312 |       401 
stores run out + EXPE |        46         55        308 |       409 
stores close + EXPERT |        32         51        312 |       395 
----------------------+---------------------------------+----------
                Total |       178        253      1,592 |     2,023 

. 
. *create indicator whereby 1 = not sure and 0 = yes/no on the ban
. generate dk_gouge=.
(2,023 missing values generated)

.         *yes, supprt law
. replace dk_gouge=0 if q39==1 | q41==1 | q43==1 | q45==1 | q46==1
(1,592 real changes made)

.         *no, do not support law
. replace dk_gouge=0 if q39==2 | q41==2 | q43==2 | q45==2 | q46==2
(178 real changes made)

.         *dk
. replace dk_gouge=1 if q39==3 | q41==3 | q43==3 | q45==3 | q46==3
(253 real changes made)

.         *stats/check coding
. tab q39

        Q39 |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |        347       84.02       84.02
          2 |         29        7.02       91.04
          3 |         37        8.96      100.00
------------+-----------------------------------
      Total |        413      100.00

. tab q41

        Q41 |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |        313       77.28       77.28
          2 |         40        9.88       87.16
          3 |         52       12.84      100.00
------------+-----------------------------------
      Total |        405      100.00

. tab q43

        Q43 |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |        312       77.81       77.81
          2 |         31        7.73       85.54
          3 |         58       14.46      100.00
------------+-----------------------------------
      Total |        401      100.00

. tab q45

        Q45 |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |        308       75.31       75.31
          2 |         46       11.25       86.55
          3 |         55       13.45      100.00
------------+-----------------------------------
      Total |        409      100.00

. tab q46

        Q46 |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |        312       78.99       78.99
          2 |         32        8.10       87.09
          3 |         51       12.91      100.00
------------+-----------------------------------
      Total |        395      100.00

. tab dk_gouge

   dk_gouge |      Freq.     Percent        Cum.
------------+-----------------------------------
          0 |      1,770       87.49       87.49
          1 |        253       12.51      100.00
------------+-----------------------------------
      Total |      2,023      100.00

.         *look at dk's by treatment condition
. tab gouge dk_gouge

                      |       dk_gouge
                gouge |         0          1 |     Total
----------------------+----------------------+----------
              control |       376         37 |       413 
       stores run out |       353         52 |       405 
         stores close |       343         58 |       401 
stores run out + EXPE |       354         55 |       409 
stores close + EXPERT |       344         51 |       395 
----------------------+----------------------+----------
                Total |     1,770        253 |     2,023 

. 
. *combine and code y/n on PRO anti-gouging law regardless of treatment (dropping DK responses; 1 = yes ban gouging, 0 =
>  no don't)
. generate no_gouge_nodk=.
(2,023 missing values generated)

. replace no_gouge_nodk=1 if q39==1
(347 real changes made)

. replace no_gouge_nodk=0 if q39==2
(29 real changes made)

. replace no_gouge_nodk=1 if q41==1
(313 real changes made)

. replace no_gouge_nodk=0 if q41==2
(40 real changes made)

. replace no_gouge_nodk=1 if q43==1
(312 real changes made)

. replace no_gouge_nodk=0 if q43==2
(31 real changes made)

. replace no_gouge_nodk=1 if q45==1
(308 real changes made)

. replace no_gouge_nodk=0 if q45==2
(46 real changes made)

. replace no_gouge_nodk=1 if q46==1
(312 real changes made)

. replace no_gouge_nodk=0 if q46==2
(32 real changes made)

. tab q39

        Q39 |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |        347       84.02       84.02
          2 |         29        7.02       91.04
          3 |         37        8.96      100.00
------------+-----------------------------------
      Total |        413      100.00

. tab q41

        Q41 |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |        313       77.28       77.28
          2 |         40        9.88       87.16
          3 |         52       12.84      100.00
------------+-----------------------------------
      Total |        405      100.00

. tab q43

        Q43 |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |        312       77.81       77.81
          2 |         31        7.73       85.54
          3 |         58       14.46      100.00
------------+-----------------------------------
      Total |        401      100.00

. tab q45

        Q45 |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |        308       75.31       75.31
          2 |         46       11.25       86.55
          3 |         55       13.45      100.00
------------+-----------------------------------
      Total |        409      100.00

. tab q46

        Q46 |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |        312       78.99       78.99
          2 |         32        8.10       87.09
          3 |         51       12.91      100.00
------------+-----------------------------------
      Total |        395      100.00

. tab no_gouge_nodk

no_gouge_no |
         dk |      Freq.     Percent        Cum.
------------+-----------------------------------
          0 |        178       10.06       10.06
          1 |      1,592       89.94      100.00
------------+-----------------------------------
      Total |      1,770      100.00

. 
. *ANOVA (note: controling for age [q5] and education [q3] due to imbalance in random assignemnt)
. anova no_gouge_nodk gouge q5 q3

                         Number of obs =      1,770    R-squared     =  0.0787
                         Root MSE      =    .295172    Adj R-squared =  0.0373

                  Source | Partial SS         df         MS        F    Prob>F
              -----------+----------------------------------------------------
                   Model |  12.594359         76   .16571525      1.90  0.0000
                         |
                   gouge |  .52126265          4   .13031566      1.50  0.2010
                      q5 |  10.761725         67   .16062277      1.84  0.0001
                      q3 |  .68648845          5   .13729769      1.58  0.1637
                         |
                Residual |  147.50508      1,693   .08712645  
              -----------+----------------------------------------------------
                   Total |  160.09944      1,769   .09050279  

. margins gouge

Predictive margins                                       Number of obs = 1,770

Expression: Linear prediction, predict()

-------------------------------------------------------------------------------------------
                          |            Delta-method
                          |     Margin   std. err.      t    P>|t|     [95% conf. interval]
--------------------------+----------------------------------------------------------------
                    gouge |
                 control  |   .9233542   .0155174    59.50   0.000     .8929189    .9537895
          stores run out  |   .8882628   .0159427    55.72   0.000     .8569934    .9195323
            stores close  |   .9016899   .0162924    55.34   0.000     .8697346    .9336452
stores run out + EXPERT   |   .8730289   .0159216    54.83   0.000     .8418008    .9042571
   stores close + EXPERT  |   .9096807   .0161625    56.28   0.000     .8779802    .9413812
-------------------------------------------------------------------------------------------

.         *now run interacted w/ pid
. anova no_gouge_nodk gouge##q11a q5 q3

                         Number of obs =      1,770    R-squared     =  0.0865
                         Root MSE      =    .295217    Adj R-squared =  0.0370

                  Source | Partial SS         df         MS        F    Prob>F
              -----------+----------------------------------------------------
                   Model |  13.856131         91   .15226518      1.75  0.0000
                         |
                   gouge |  .42409321          4    .1060233      1.22  0.3018
                    q11a |  .34343153          3   .11447718      1.31  0.2683
              gouge#q11a |  .91858761         12   .07654897      0.88  0.5689
                      q5 |  10.633331         67   .15870643      1.82  0.0001
                      q3 |  .70705801          5    .1414116      1.62  0.1508
                         |
                Residual |   146.2433      1,678   .08715334  
              -----------+----------------------------------------------------
                   Total |  160.09944      1,769   .09050279  

. 
. *for reviewer, replicate the above ANOVA comparing the four treatments pooled to control
. anova no_gouge_nodk gouge_pooled q5 q3

                         Number of obs =      1,770    R-squared     =  0.0770
                         Root MSE      =    .295172    Adj R-squared =  0.0373

                  Source | Partial SS         df         MS        F    Prob>F
             ------------+----------------------------------------------------
                   Model |   12.33282         73   .16894273      1.94  0.0000
                         |
             gouge_poo~d |  .25972295          1   .25972295      2.98  0.0844
                      q5 |  10.878458         67   .16236504      1.86  0.0000
                      q3 |  .66627891          5   .13325578      1.53  0.1774
                         |
                Residual |  147.76662      1,696   .08712654  
             ------------+----------------------------------------------------
                   Total |  160.09944      1,769   .09050279  

. 
. *for reviewer, repliace the ANOVA comparing the two non-expert treatments pooled to the two expert treatments pooled
.         *make the IV
. recode gouge (1=.) (2=0) (3=0) (4=1) (5=1), gen(gouge_expert_vs_no)
(2023 differences between gouge and gouge_expert_vs_no)

. tab gouge gouge_expert_vs_no

                      |    RECODE of gouge
                gouge |         0          1 |     Total
----------------------+----------------------+----------
       stores run out |       405          0 |       405 
         stores close |       401          0 |       401 
stores run out + EXPE |         0        409 |       409 
stores close + EXPERT |         0        395 |       395 
----------------------+----------------------+----------
                Total |       806        804 |     1,610 

.         *analysis
. anova no_gouge_nodk gouge_expert_vs_no q5 q3

                         Number of obs =      1,394    R-squared     =  0.0812
                         Root MSE      =    .304229    Adj R-squared =  0.0311

                  Source | Partial SS         df         MS        F    Prob>F
             ------------+----------------------------------------------------
                   Model |  10.808634         72   .15011991      1.62  0.0010
                         |
             gouge_exp~o |  .00620104          1   .00620104      0.07  0.7958
                      q5 |  9.9674765         66   .15102237      1.63  0.0013
                      q3 |  .43026342          5   .08605268      0.93  0.4606
                         |
                Residual |  122.26525      1,321   .09255508  
             ------------+----------------------------------------------------
                   Total |  133.07389      1,393   .09553043  

. 
. *for reviewer (put in supplement): replicate analysis with the "not sure" respondents
.         *not sure vs all other responses
. anova dk_gouge gouge q5 q3

                         Number of obs =      2,023    R-squared     =  0.0464
                         Root MSE      =    .329434    Adj R-squared =  0.0087

                  Source | Partial SS         df         MS        F    Prob>F
              -----------+----------------------------------------------------
                   Model |  10.274656         77   .13343709      1.23  0.0888
                         |
                   gouge |  .66413943          4   .16603486      1.53  0.1909
                      q5 |  7.6916511         68   .11311252      1.04  0.3848
                      q3 |  1.5137392          5   .30274784      2.79  0.0162
                         |
                Residual |  211.08471      1,945   .10852684  
              -----------+----------------------------------------------------
                   Total |  221.35937      2,022   .10947545  

. 
. *save out truncated dataset
. save "/Users/caseyklofstad/Dropbox/Effects, Impacts and Influences of Hurricane Irma/irma paper 2 BUSINESS price gougi
> ng experiment/replication files/study 2 data for replication.dta", replace
(file /Users/caseyklofstad/Dropbox/Effects, Impacts and Influences of Hurricane Irma/irma paper 2 BUSINESS price
    gouging experiment/replication files/study 2 data for replication.dta not found)
file /Users/caseyklofstad/Dropbox/Effects, Impacts and Influences of Hurricane Irma/irma paper 2 BUSINESS price
    gouging experiment/replication files/study 2 data for replication.dta saved

. 
. *close log
. log close
      name:  <unnamed>
       log:  /Users/caseyklofstad/Dropbox/Effects, Impacts and Influences of Hurricane Irma/irma paper 2 BUSINESS price 
> gouging experiment/replication files/study 2 log.log
  log type:  text
 closed on:   8 Feb 2023, 16:10:52
------------------------------------------------------------------------------------------------------------------------
